package com.alibaba.ai.dao;

import com.alibaba.ai.entity.Evaluate;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface EvaluateMapper {
    // 房源评估，立即评估
 @Select("select *from(select *from C_EVALUATE left join C_DETAILS on C_EVALUATE.id=C_DETAILS.C_DATEILS_ID) as C_EVALUATE left join E_ORIENTATION ON C_EVALUATE.C_ORIENTATION_ID=E_ORIENTATION.id where cVillageName,cOrientationId,cArea,cFloor,cTotalfloor")
    List<Evaluate> selectByEvaluate(String cVillageName, String cOrientationId, String cArea, Integer cFloor, Integer cTotalfloor);
}
